﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Jzy.Model.Task
{
    public partial class TaskInfo
    {
        public const string TABLE_NAME = "Task";
        public const string INSERT_SQL = "insert into Task ( [ID], [Name], [StartTime], [EndTime], [State], [Priority], [CreatorID], [CreatorName], [LeaderID], [LeaderName], [JoinerNames], [Remark], [InputTime], [Result]) values ( @ID, @Name, @StartTime, @EndTime, @State, @Priority, @CreatorID, @CreatorName, @LeaderID, @LeaderName, @JoinerNames, @Remark, @InputTime, @Result)";
        public const string UPDATE_SQL = "update Task set  [ID] = @ID, [Name] = @Name, [StartTime] = @StartTime, [EndTime] = @EndTime, [State] = @State, [Priority] = @Priority, [CreatorID] = @CreatorID, [CreatorName] = @CreatorName, [LeaderID] = @LeaderID, [LeaderName] = @LeaderName, [JoinerNames] = @JoinerNames, [Remark] = @Remark, [InputTime] = @InputTime, [Result] = @Result where ID = @ID";
        /// <summary>
        /// 
        /// </summary>
        public Int32 ID
        {
            get;
            set;
        }
        /// <summary>
        /// 标题
        /// </summary>
        public String Name
        {
            get;
            set;
        }
        /// <summary>
        /// 开始时间
        /// </summary>
        public DateTime? StartTime
        {
            get;
            set;
        }
        /// <summary>
        /// 结束时间
        /// </summary>
        public DateTime? EndTime
        {
            get;
            set;
        }
        /// <summary>
        /// 状态
        /// </summary>
        public Int32 State
        {
            get;
            set;
        }
        /// <summary>
        /// 优先级
        /// </summary>
        public Int32 Priority
        {
            get;
            set;
        }
        /// <summary>
        /// 创建人ID
        /// </summary>
        public Int32 CreatorID
        {
            get;
            set;
        }
        /// <summary>
        /// 创建人姓名
        /// </summary>
        public String CreatorName
        {
            get;
            set;
        }
        /// <summary>
        /// 负责人ID
        /// </summary>
        public Int32 LeaderID
        {
            get;
            set;
        }
        /// <summary>
        /// 负责人姓名
        /// </summary>
        public String LeaderName
        {
            get;
            set;
        }
        /// <summary>
        /// 参与人姓名
        /// </summary>
        public String JoinerNames
        {
            get;
            set;
        }
        /// <summary>
        /// 备注
        /// </summary>
        public String Remark
        {
            get;
            set;
        }
        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime InputTime
        {
            get;
            set;
        }
        /// <summary>
        /// 考核结果,如果为空表示还没有考核
        /// </summary>
        public Int32? Result
        {
            get;
            set;
        }
    }

}
